package test.android;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper{
	private static final String DB_NAME = "nkl.sqlite";
	private static final int DB_VERSION = 1;
	
	public static String TB_FAVOURITE_ALBUMS = "favourite_album";
	public static String CL_FAVOURITE_ALBUM_ID = "album_id";
	public static String CL_FAVOURITE_ALBUM_NAME = "album_name";
	private String CREATE_TB_FAVOURITE_ALBUMS = "CREATE TABLE favourite_album (album_id text not null, album_name text not null)";
	
	public DatabaseHelper(Context context) {
		// TODO Auto-generated constructor stub
		super(context, DB_NAME, null, DB_VERSION);
	}
	
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL(CREATE_TB_FAVOURITE_ALBUMS);
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		
	}
}
